package pers.cj.pdos.mapper;

import org.apache.ibatis.annotations.Param;
import pers.cj.pdos.entity.Goods;
import pers.cj.pdos.entity.GoodsHouseWarn;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import pers.cj.pdos.vo.GoodsHouseWarnVo;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author chenj
 * @since 2019-11-04
 */
public interface GoodsHouseWarnMapper extends BaseMapper<GoodsHouseWarn> {

    void insertBatch(@Param("list") List<GoodsHouseWarn> list);

    void batchDeleteByGoodsList(@Param("list")List<Goods> list);

    Long countMinNumber(@Param("companyId")String companyId);

    Long countMaxNumber(@Param("companyId")String companyId);

    List<GoodsHouseWarnVo> listVo(@Param("companyId")String companyId,
                                  @Param("page") Integer page,
                                  @Param("limit") Integer limit,
                                  @Param("storeId") String storeId,
                                  @Param("houseId") String houseId,
                                  @Param("type") Integer type,
                                  @Param("typeId") String typeId,
                                  @Param("search") String search);

    long count(@Param("companyId")String companyId,
               @Param("storeId") String storeId,
               @Param("houseId") String houseId,
               @Param("type") Integer type,
               @Param("typeId") String typeId,
               @Param("search") String search);
}
